package Example01;
import java.sql.*;
public class Example01 {
public static void main (String[] args) throws SQLException{
Statement stmt = null;
ResultSet rs = null;
Connection conn = null;
try {
 // 1.注册数据库的驱动
Class.forName("com.mysql.cj.jabc.Driver");
String url=
"jdbc:mysql://localhost:3306/jdbc?serverTimezone=GMT%2B8&useSSL=false"; //localhost指的是谁的数据库能修改 jdbc修改mysql数据库
String username = "ggh";
String password = "ggh.052550";
conn= DriverManager.getConnection(url,username,password);
stmt = conn.createStatement();
String sql = "select*from users";
rs = stmt.executeQuery(sql);
System.out.println("id|  name   |   password "+"|   email   |    birthday");
while (rs.next()){
int id = rs.getInt("id");
String name = rs.getString("name");
String psw = rs.getString("password");
String email = rs.getString("email");
Date birthday = rs.getDate("birthday");
System.out.println(id+"    |    "+name+"   |   "+psw+"    |    "+email+ "   |   "+birthday);
}
}catch(ClassNotFoundException e ){
    e.printStackTrace();
}finally{
    if (rs != null);{
        try{
            rs.close();
        }catch(SQLException e){
            e.printStackTrace();
        }
        rs=null;
    }
    if (stmt!=null){
        try{
            stmt.close();
        }catch (SQLException e){
            e.printStackTrace();
        }
        stmt = null;
    }
    if (conn != null){
        try{
            conn.close();
        }catch (SQLException e){
            e.printStackTrace();
        }
        conn = null;
                }
            }
        }
    }
